﻿CREATE TABLE [dbo].[ProductSpecProp] (
    [ProductBaseID] BIGINT           NOT NULL,
    [SpecID]        INT              NOT NULL,
    [PropID]        BIGINT           IDENTITY (10001, 1) NOT NULL,
    [PropName]      NVARCHAR (50)    NOT NULL,
    [ImageID]       UNIQUEIDENTIFIER NULL,
    [IsDelete]      BIT              NOT NULL,
    [Sort]          INT              NOT NULL,
    CONSTRAINT [PK_ProductSpecProp] PRIMARY KEY CLUSTERED ([PropID] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'排序', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductSpecProp', @level2type = N'COLUMN', @level2name = N'Sort';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'已删除', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductSpecProp', @level2type = N'COLUMN', @level2name = N'IsDelete';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'图片标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductSpecProp', @level2type = N'COLUMN', @level2name = N'ImageID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'属性名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductSpecProp', @level2type = N'COLUMN', @level2name = N'PropName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'属性标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductSpecProp', @level2type = N'COLUMN', @level2name = N'PropID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'规格标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductSpecProp', @level2type = N'COLUMN', @level2name = N'SpecID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'商品基本信息标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductSpecProp', @level2type = N'COLUMN', @level2name = N'ProductBaseID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'商品规格属性', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductSpecProp';

